/*
 Navicat Premium Data Transfer

 Source Server         : MySQL-Docker
 Source Server Type    : MySQL
 Source Server Version : 80016
 Source Schema         : basketballclub

 Target Server Type    : MySQL
 Target Server Version : 80016
 File Encoding         : 65001

 Date: 14/10/2021 15:46:59
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for clubdate
-- ----------------------------
DROP TABLE IF EXISTS `clubdate`;
CREATE TABLE `clubdate` (
  `id` bigint(20) NOT NULL,
  `date` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of clubdate
-- ----------------------------
BEGIN;
INSERT INTO `clubdate` VALUES (1, 4);
INSERT INTO `clubdate` VALUES (2, 5);
COMMIT;

-- ----------------------------
-- Table structure for hibernate_sequence
-- ----------------------------
DROP TABLE IF EXISTS `hibernate_sequence`;
CREATE TABLE `hibernate_sequence` (
  `next_val` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of hibernate_sequence
-- ----------------------------
BEGIN;
INSERT INTO `hibernate_sequence` VALUES (10);
INSERT INTO `hibernate_sequence` VALUES (10);
INSERT INTO `hibernate_sequence` VALUES (10);
COMMIT;

-- ----------------------------
-- Table structure for player
-- ----------------------------
DROP TABLE IF EXISTS `player`;
CREATE TABLE `player` (
  `id` bigint(20) NOT NULL,
  `email` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `sec` varchar(255) NOT NULL,
  `state` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of player
-- ----------------------------
BEGIN;
INSERT INTO `player` VALUES (1, '***1@***.com', '***', 'f76cfb00aa68467c9457ba21c8cd50fe', 'Y');
COMMIT;

-- ----------------------------
-- Table structure for record
-- ----------------------------
DROP TABLE IF EXISTS `record`;
CREATE TABLE `record` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `event_date` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `state` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of record
-- ----------------------------
BEGIN;
INSERT INTO `record` VALUES (6, '2021-10-14', '***', 'Y');
INSERT INTO `record` VALUES (7, '2021-10-14', '***', 'Y');
INSERT INTO `record` VALUES (8, '2021-10-14', '***', 'Y');
INSERT INTO `record` VALUES (9, '2021-10-14', '***', 'Y');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
